1 / 12

Add Reporting and Analytics to MySQL Data in 10 minutes

Discover how to integrate reporting and analytics into your MySQL database within just 10 minutes! Join Rushabh Mehta, Managing Director at Solid Quality Mentors, as he guides you through simplified data mash-ups, extensive reporting, and the transition from self-service to managed Business Intelligence (BI). Learn about leveraging technologies like MySQL, PowerPivot for Excel 2010, and SQL Server 2008 R2 to create a robust analytical model for effective data analysis and decision-making.

Samuel
Télécharger la présentation

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