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!
This card is an excellent reference for PowerPivot users. Its also free and available Giving Back: “Steal” this Reference Card!
The host web site http://www.powerpivotpro.com/ is also worth bookmarking!
This is an excellent Ted talk about open data, gives practical examples and raises the need for consistent standards for data provided by Government.
There is a follow on discussion needed here about government making data public and in a form where the public can explore it and draw their own conclusions and effectively debate and discuss government plans and proposals.
If you follow this talk back to Ted, you will find a whole set of Data related talks, I recommend the one by Amy Webb.
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
Twitter is an undervalued resource for leads to IT and Business resources. But as I am only able to review my Twitter account every couple of days, I felt I wasn’t getting value out of it, just seeing masses of posts. So I have set up some lists, which filter the accounts you follow by categories you create. I know I am the last person to discover this feature, but really useful, all the same!
You might find them useful, so here they are: Continue reading “Twitter Lists make Twitter manageable. Here are some I made earlier…”
On Friday, I was catching up on my podcasts and listing to Hilton Giesenow‘s The MOSS Show and in Episode 34 Hilton interviews Pej Javaheri from the SharePoint B.I. team at Microsoft about Business Intelligence and SharePoint.
What got my attention was PowerPivot which is an add-in for Excel or SharePoint that allows you to connect to large tables of data to do pivot table analysis.