This article shows how to navigate in your Excel workbook with ease. Below is a basic sample worksheet. Notice the Name Box. When you place your mouse near or over that area, the description
appears. The usefulness of this small feature is a bit overwhelming. For now, it is good to know that not only does it show the current cell’s address, it can also be used as a ‘Go To’ box. If you know exactly or even approximately where you want to go, this little portal can take you there quickly.
Excel is the tool of choice for getting data ready for import. Data is brought into Excel directly from the legacy program, or it is imported as a delimited file created by another application. Once the data is in Excel there are several strategies to prepare it for import. This article shows how easy it is to filter data with just the click of a mouse.
Initially when Dynamics CRM Online was introduced it was tied to windows live id, Microsoft’s online authentication platform. Since then it has been replaced by Office 365 login. And it’s not just that Dynamics CRM Online authentication that has moved to Office 365, now there is lot more integration between these 2 systems. The latest one is the connection between Power BI and Dynamics CRM using Office 365. You can find additional details of the same at
I often get asked about Business Intelligence and related tools, as dashboards and data integration have become so common today, and everyone wants “instant information”. After all, aren’t we all information workers today?
Since my company is a Microsoft Partner, doing Dynamics (GP, SL and CRM) business applications, my first recommendation is to “look close to home”. You may be surprised how much existing BI you already own and are not utilizing if you use Microsoft products. (Dynamics, SQL, SharePoint, Office) The Microsoft BI toolkit is not a lightweight player in the BI market, as you can see from the 2013 Gartner’s Magic Quadrant graphic below.
We have put a lot of hard work into this blog series with building a patron analysis so now it’s time to share the wealth of our analysis insights with the rest of the company. Power BI’s web site and mobile approach with the deployment of Office 365 and refreshable data through a Data Management Gateway, is the perfect solution. The Data Management Gateway has come a long way since the first version and with version 1.2 it now supports many data source types from Power Query connections.
Over the last several years we have heard a lot about the cloud: How easy it is to move business applications to the cloud; how IT departments are making this part of their strategic business plans; and the different initiatives coming about on how to save companies money and gain efficiencies. IT is now able to off load hardware and software administrative and resource overhead to hosting providers. This is empowering them to not only concentration on, but to be a PART of, strategic technology planning efforts for their organizations. This is an overall benefit to the organization, and I believe an unexpected but welcomed result of the cloud movement.