Successfully completed “Business Metrics for Data-Driven Companies” by Duke University on Coursera. First step in a five step process. The main purpose was to get an understanding of data analysis and what Data Analysts do, because I get many of them on my Advanced Excel and Excel Power Pivot courses.
I am glad I did it, learned a lot that I can use in my own business. I’d recommend it!
Signed up for “Business Metrics for Data-Driven Companies” the first course of a 5-course series, the Excel to MySQL: Analytic Techniques for Business Specialization. Enjoyed the Microsoft edX course I did recently, so I thought I’d do more.
Thought it was a fit and should help with the questions I get from Business Analysts on Excel and SharePoint Courses.
Give me 25 minutes and I will show you how to add data to an existing Power Pivot using Power Query. Add data from Excel and CSV files.
This process is useful if you need to periodically add new data e.g. monthly.
Make your first step into Business Intelligence tools by using data in Excel worksheets and Power Pivot
Learn how to:
– add to data model
– create relationships
– add calculated columns
– create a pivot table
– see one approach for grouping by dates
Lesson One in a series where I aim to introduce you to the “Power Tools” for Excel 2013 and SharePoint
I have just been catching up on my pod cast listening while cleaning up my office (a task worthy of Time Team and also really requiring three days). Episode 56 of the SharePoint Pod Show (also available via iTunes) has an interesting interview with Jeff Huckaby. In the interview they discuss the practical application of reports in SharePoint to a nationwide Truck Stop business. Continue reading “Is your Gum upside-down? The value of SharePoint 2010 Business Intelligence”