ngflow.blogg.se - Business intelligence development studio for mac

#Business intelligence development studio for mac mac os#
#Business intelligence development studio for mac windows#

Used HTML, JavaScript to embed the dashboards and Ad-hoc data sources into Nike Analytics portal.

Written SQL queries to validate the data displayed on the dashboards.

Connect to different data sources such as Amazon Redshift, Athena, Snowflake, CDH and Excel and build dashboards using data blending, cross database joins, parameters, calculated fields, LOD expressions, and action filters.

Made significant improvements that led to better load times and made it more user-friendly.

Involved in performance tuning, rearchitecting and developing new features for Scoreboard dashboard, which is used by all the store managers.

Created multiple dashboards in Agile environment, that were first published in Pre-Prod server for initial review, suggestions and further data analysis, and then published to the Prod Server.

Responsible for interaction with business stake holders, gathering requirements and managing the delivery.

Other Tools: MS Office Suite (Microsoft Word, Power Point, MS Visio, MS Access), ERWINĮnvironment: Tableau Desktop 10.3, 10.5, Tableau Server, Hive, Sqoop, AWS EMR, AWS S3, CDH, Athena, Snowflake, Redshift, HTML, Metric Insights

#Business intelligence development studio for mac mac os#

Operating Systems: Windows, UNIX, Linux, Mac OS

#Business intelligence development studio for mac windows#

Experience in using tools like Index Tuning Wizard, SQL Profiler, and Windows Performance Monitor for Monitoring and Tuning MS SQL Server Performance.ĭata Visualization Tools: Tableau, DOMO, Informatica, Crystal Reporting, SQL Server Reporting Services, Business Objects.īig Data: Hive, Sqoop, AWS EMR, AWS S3, CDHĮTL Tools: Tableau Prep, Alteryx, Informatica, SSISĭatabase Tools: Teradata SQL Assistant, SQL Enterprise Manager, Query Analyzer, SQL Server Management Studio, Business Intelligence Development Studio.ĭatabases: Teradata, MS SQL Server, MS Access, Oracle, MySQL, PostgreSQL.Strong knowledge of Data Warehousing methodologies and concepts, including star schemas, snowflakes, dimensional modeling and reporting tools.Experienced in tuning long running SQL queries for better performance.Proficiency in creating many complex SSIS packages with complicated transformations using SQL Server Integration Services.

Responsible for writing SQL Queries, Dynamic queries, sub queries and complex joins for generating complex Stored Procedures, Triggers, User defined Functions, Views and Cursors.Experience with Erwin logical/physical DB diagrams design, reverse engineering, reports.Good knowledge of Relational database and Data Modeling concepts and possess extensive experience in development of T-SQL, PL/SQL, Functions, Stored Procedures, Triggers and ActiveX Scripts.Wide experience in creating OLAP cubes, identifying dimensions, attributes, hierarchies and calculating measures and dimension members.Experience in designing and implementing ETL environments using ETL strategies as well as tools like SSIS.Extensive experience in MSBI stacks like SSRS, SSIS, SSAS.Experience working with Big Data technologies such as H iv e, S qoop, AWS EMR, AWS S3, CDH.Experience in Administering user, user groups, and scheduled instances for reports in Tableau.Expertise in Performance Tuning Tableau Dashboards and Reports built on huge Data sources.Worked extensively on joining tables, multiple data connections using data blending, worked on Data Extracts and managing queries.Expertise in designing and creating various analytical reports and Dashboards to help users to identify critical KPIs and facilitate strategic planning in the organization.Expertise in development of Tableau visualizations which includes preparing dashboards using various reporting objects such as facts, attributes, transformations, filters, prompts, calculated fields, parameters, groups, sets and hierarchies.Created solution driven dashboards by developing different chart types including Crosstabs,Heat/Geo/Tree Maps, Pie/Bar Charts, Circle Views, Line/Area Charts, Scatter Plots, Bullet Graphs, and Histograms in Tableau Desktop.Extensive TableauExperience in Enterprise Environment and Tableau Administrator experience including technical support, troubleshooting, report design and monitoring of system usage.Experience in installation, Configuration and administration of Tableau Server in multi - server and multi-tier environment.Created dashboards by connecting to various data sources such as Amazon Redshift, Athena, Snowflake, CDH, Teradata, SQL Server and Excel.Good understanding of Tableau Desktop architecture for designing and developing dashboards.6+ years of IT Experience as a Tableau Developer/ Data Analystin Data Warehousing and Business Intelligence Projects.