1 / 12

Add Reporting and Analytics to MySQL Data in 10 minutes

Add Reporting and Analytics to MySQL Data in 10 minutes. Journey from self-service to managed BI Rushabh Mehta, Mentor and Managing Director (India) Solid Quality Mentors www.solidq.com. Goals. Simplified data mash-up and analysis Extended Reporting Managed BI Goal #1 – BI in 10 minutes!.

Samuel
Download Presentation

Add Reporting and Analytics to MySQL Data in 10 minutes

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Add Reporting and Analytics to MySQL Data in 10 minutes • Journey from self-service to managed BI • Rushabh Mehta, Mentor and Managing Director (India) • Solid Quality Mentors • www.solidq.com

  2. Goals • Simplified data mash-up and analysis • Extended Reporting • Managed BI • Goal #1 – BI in 10 minutes!

  3. Sales Data Dimensional Model

  4. Considerations • Sales data processed into a Relational Dimensional Model • Data Cleansing already done as part of loading Model • Using MyISAM storage for rapid reporting

  5. DEMO • Analyzing MySQL data

  6. Technologies Used • On Network • Data Sources • MySQL Database (Release 5.1.45) – Sales data • ATOM Data Feeds • On Client Machine [The Information Worker] • Data Sources • Text File • Excel • Drivers • MySQL Connector-ODBC 5.1.6 – DSN created to MySQL database • Data manipulation, model creation and analysis technologies • Excel 2010 • PowerPivot Add-in for Excel 2010

  7. DEMO • Extended Reporting • Reports against Analytical Model • Reports against MySQL

  8. Technologies Used • On Network • Microsoft SharePoint Server 2010 • Excel Services, PowerPivot Service, Analysis Services and Reporting Services • MySQL Connector-ODBC 5.1.6 and DSN • On Developer Machine [The Report Creator] • Business Intelligence Development Studio • MySQL Connector-ODBC 5.1.6 and DSN • On Client Machine [The Information Worker or Report Consumer] • Internet Explorer • .NET Framework

  9. DEMO • Managed BI Solution • Managed Analytical Model

  10. Technologies Used • On Network • MySQL Database • Sales Database • SQL Server 2008 R2 • Analysis Services and Database Engine (additional data) • MySQL ADO.NET Provider • On Developer Machine [The Model Creator] • Business Intelligence Development Studio • MySQL ADO.NET Provider • On Client Machine [The Information Worker or Information Consumer] • Excel • Other client tools for OLAP

  11. References • Technology References • www.powerpivot.com • www.microsoft.com/BI • www.sqlpass.org (Free 300+ Hours of deep technical recorded content) • Upcoming Free Educational Series • 24 Hours of PASS R2 (http://www.sqlpass.org/24hours/2010/) • Implementation and Training • www.solidq.com • Emails • Info @ solidq.com • Rmehta @ solidq.com

  12. THANK YOU

More Related