Add reporting and analytics to mysql data in 10 minutes
This presentation is the property of its rightful owner.
Sponsored Links
1 / 12

Add Reporting and Analytics to MySQL Data in 10 minutes PowerPoint PPT Presentation


  • 69 Views
  • Uploaded on
  • Presentation posted in: General

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!.

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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -

Presentation Transcript


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

Goals

  • Simplified data mash-up and analysis

  • Extended Reporting

  • Managed BI

  • Goal #1 – BI in 10 minutes!


Sales data dimensional model

Sales Data Dimensional Model


Considerations

Considerations

  • Sales data processed into a Relational Dimensional Model

  • Data Cleansing already done as part of loading Model

  • Using MyISAM storage for rapid reporting


Add reporting and analytics to mysql data in 10 minutes

DEMO

  • Analyzing MySQL data


Technologies used

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


Add reporting and analytics to mysql data in 10 minutes

DEMO

  • Extended Reporting

  • Reports against Analytical Model

  • Reports against MySQL


Technologies used1

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


  • Add reporting and analytics to mysql data in 10 minutes

    DEMO

    • Managed BI Solution

    • Managed Analytical Model


    Technologies used2

    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


  • References

    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


    Thank you

    THANK YOU


  • Login