Thu, Jul 17, 2014 12:00 PM – 1:00 PM EDT
Many companies are starting or expanding their use of data mining and machine learning. This presentation covers seven practical ideas for encouraging advanced analytics in your organization.
Mark Tabladillo is a Microsoft MVP and SAS expert based in Atlanta, GA. His Industrial Engineering doctorate (including applied statistics) is from Georgia Tech. Today, he helps teams become more confident in making actionable business decisions through the use of data mining and analytics. Mark provides training and consulting for companies in the US and around the world. He has spoken at major conferences including Microsoft TechEd, PASS Summit, PASS Business Analytics Conference, Predictive Analytics World, and SAS Global Forum. He tweets @marktabnet and blogs at http://marktab.net.
hope to see you there!
Business Analytics Virtual Chapter’s Co-Leader
The goal of this blog post is to share a quick tip on SQL Server Reporting Services (SSRS): How to add Trademark TM special symbol in Text?
In SSRS, you can put following code in the Expressions:
="Text"& ChrW(8482) &" Dashboard"
what an inspiring keynote by David McCandless! Here are some the things that I noted:
1. Play with your data, get your hands dirty
“Data is the new Soil” – David McCandless
2. set the context while communicating what data is trying to tell.
Example: China has the largest army but compared it to their population they are 120ish! So measuring just the army size does not give you necessary context & sometimes it can meaningless
3. Data visualizations help you combine the language of the mind (numbers) with language of the eye (visuals)! Humans are better at processing visuals.
4. Make sure your data is true & keep your personal bias out of analysis.
5. Other than making sure that the data integrity is achieved in visuals, they should be interesting and functional.
6. Design is about removing unwanted things & distilling the visual to it’s functional essence.
You can check out David’s work at http://www.informationisbeautiful.net/
I’m at the Business Analytics conference and I thought of sharing the news that I get to listen here!
On day #1, Kamal Hathi & Amri Netz are keynote speakers today.
They started with progress made during past few months (Power Query, Power BI, Power Map, SQL server 2014, Azure HDInsight….)
Then they shared some user adoption data…
Power Pivot & Power Query:
They also shared user adoption data about Power BI:
They use Power BI to track user adoption of Power BI.
Power BI demo contest: if you’ve not seen some of the amazing demo’s that were submitted during the Power BI demo’s then you can read them here: http://blogs.msdn.com/b/powerbi/archive/2014/02/15/give-a-high-five-to-the-top-five-finalists-in-the-power-bi-demo-contest.aspx
Microsoft is committed to having Power BI native apps on different platforms and enable BI on any device
SSRS with Power BI:
BI for the masses
It’s great to see Microsoft committed to create easy to use tools!
The Age of Classic BI -> The Age of Self Service BI -> The Age of Data.
In the new age, everyone in the organization who is curious will have tools that they can use to get to the answers!
Analysis of Tourism in Hawaii. It was really entertaining :)
New features in Power BI:
create dashboards using natural language (KPI editor)
Forecasting in Power View:
Tree maps in Power View
And I just saw a Tree maps in Power View!
Drag items from one chart to another!
you should now be able to drag items from one chart to another chart!
Combine two charts into one!
Nice interactivity feature
The journey to DATA CULTURE begins today…
In part #1, I wrote about why is it important to enable business users to create their own BI reports.
In part #2, I wrote about three pre-training preparations – 1. Data 2. Tool 3. Understanding Culture.
In part #3, I wrote about 1. User Experience 2. Trainer 3. Training Content.
In this post, I am going share sample training content that uses Excel 2010. Before I share sample content, here are some tips
1. use YOUR data!
2. Show them the end goal & then walk through the steps to get there
Here’s a sample training content for a 4 hour-long excel training session (divided into basics & advanced) including hands on lab time.
Here you go:
- Open the Template
- Explore the Field List
- Explain the concept of “dimensions” & “measures”
- Create a Simple Pivot Table – Row Labels & Measures
- Add column labels & report filters
- Turning off grant totals
- Creating a hierarchy
- Changing the Pivot Table Design
- Remove fields from Pivot Table
- Add more than one pivot table
- Add slicer
- Connect slicer with every pivot table
- Add Pivot Chart
- Add one more slicer
- Add hierarchy structure to pivot tables
- Add conditional formatting
- Format chart
In this post, I shared a sample training content that uses Excel 2010.
I got an opportunity to speak at SQL Saturday 305 Dallas BA Edition on 5/3/14! It was a great opportunity to network, share & learn!
if you are interested in “How to Train your business users to create their own BI reports” slides then they are posted here: http://bit.ly/TrainBusinessUsers
Here’s couple of generous session evaluations I got:
Business Intelligence (BI) helps an organization make faster & smarter decisions – There’s no doubt or debate over that! But every organization needs to go through the process of driving Business Intelligence adoption before they start seeing the Return on Investment for a BI solution. One of the form of BI which has been really successful at being adopted by business community is called “self-service BI” and the idea is to enable business users to create their own reports – in other words, “self-serve” their data needs. In this blog series, I would share the best practices that I’ve picked up while leading up an effort to train 200+ business users with the goal of enabling them to create their own BI reports.
In this post, let’s step back and talk about why is it important to enable business users to create their own reports?
#1: Information Technology’s Time & Budget.
The demand for “data” by business users is a great thing! But IT would need to dedicate resources to make it happen. usually, IT teams can be constrained due to budgetary reasons or due to other higher priority items on their radar. So what happens? Business community do not receive the data that they asked for in a timely fashion. And if you cannot offer data when they need it then it might not be as useful. So what’s the solution? One solution is to have “BI platforms” where data assets are readily available for business users to consume. So once they are build, IT would no longer have to dedicate development resources on them. And since IT is no longer a bottleneck, business users can get the data when they want it and however way they want to see it.
#2: World changes. Business Changes.
World Changes and so does Business. If Business doesn’t adapt to change then they will die! And if Business changes, the data needs would change too. How many times does IT get “change requests” to their production reports? All of these requests would require IT’s intervention to accommodate change requests and what is the average turn around time in your organization for that? How about publishing data assets that businesses can readily access that let’s them see same data from varying perspectives? Of course, they might ask for data that’s not available yet but then IT can spend some time on bringing those data assets into the BI platforms rather than spending resources on “change requests”.
#3: It’s great for BI adoption!
With the flexibility of Self Service BI solution, the control is in the hands of the users (again!). Without having to wait on IT, they can get to the data instantaneously and so faster and there’s a greater chance that they would use “data” in the decision making process. Isn’t it great?
Also, business users who would have created their own reports would share it with others, won’t they? And that would spark collaboration among business users. This is great because the recipients of the reports would start wanting to analyze the data too. And with time, the trust for the data assets would grow among the business community. This is really important for BI adoption.
In this post, we saw why is it important to train your business users to create their own BI reports using a Self Service BI Platform. In next posts, we’ll get into strategies & tactics to enable users to create their own reports.