Online or onsite, instructor-led live SQL Server BI training courses in Shanghai.
Shanghai, Central Plaza
2/F, 227 North Huangpi Road, Huangpu District, Shanghai, China, 200003
The Central Plaza is located on North Huangpi Road at the West side of People's Square, with the Municipal Government, the Sh...
The Central Plaza is located on North Huangpi Road at the West side of People's Square, with the Municipal Government, the Shanghai exhibition centre and the Shanghai Museum at walking distance. People Square is the most famous administrative, commercial and cultural centre of Shanghai. People’s Square Station, connecting metro Lines 1, 2, and 8, is within walking distance. The building is a 15 minute drive to Shanghai Railway Station, and 25 minutes to Shanghai Hongqiao International Airport and High-speed Railway Station. Many 5-star hotels such as Le Meridien, the Radisson, JW Marriott Hotel, as well as various restaurants, shopping complex and financial services are located in the surrounding area. The Central Plaza offers a perfect solution for local and overseas companies looking for flexible and fully-equipped offices with comprehensive services at a reasonable price.
The Henderson 688 business center is located on the 16th floor of an international Grade A office tower of a modern developme...
The Henderson 688 business center is located on the 16th floor of an international Grade A office tower of a modern development in the heart of the bustling West Nanjing Road CBD. West Nanjing Road is one of the most famous commercial zones in Shanghai, featuring upmarket malls, prime office buildings and the Shanghai Exhibition Centre. Henderson 688 is a landmark building close to the People’s Square, providing superb workplace environment for international corporation tenants and a retail podium with an outdoor gourmet corridor designed to be the trendiest meeting hub in Shanghai.
Within its close proximity are five star hotels such as JW Marriott Hotel, Four Seasons Hotel, Park Hotel, etc. The center is conveniently served by the South-North Elevated Road and within short walk distance to Metro Line 2. It is a 25 minute drive to Hongqiao International Airport and High-speed Railway Station, and 60 minute to Pudong International Airport.
Training is dedicated to the basics of create a data warehouse environment based on MS SQL Server 2008.
Course participant gain the basis for the design and construction of a data warehouse that runs on MS SQL Server 2008.
Gain knowledge of how to build a simple ETL process based on the SSIS and then design and implement a data cube using SSAS.
The participant will be able to manage OLAP database: create and delete database OLAP Processing a partition changes on-line.
The participant will acquire knowledge of scripting XML / A and MDX.
Developers, analysts and business users need to quickly analyse large amounts of data, get insight into that data, retrieve hidden knowledge inside it, and report against various data sources professionally and effectively. This course will enable them to do this with SQL Server Business Intelligence. The 5 day course will cover the SQL Server components and tools used for B.I. projects.
The course will also include the new features in SQL Server B.I. 2016. Reporting Services, Analysis Services and Integration Services will be explored and worked with. Components of Business Intelligence in SQL Server are completely independent from the SQL Server databases, so they can be used over any data sources. Therefore, it is not necessary to know the SQL Server itself.
4 Top Takeaways from the Course
Make your existing data work harder for you
Integrate diverse data stores to a single repository
This intensive training provides the fundamental knowledge and skills to use Windows PowerShell for automating administration of Windows based computers. The skills taught in this course are applicable to all Microsoft products that use Windows PowerShell for daily administration.
Training focuses mainly on using Windows PowerShell as an interactive command line interface however it also includes some coverage of scripting and programming topics.
Online SQL Server BI (Business Intelligence) training in Shanghai, SQL Server Business Intelligence training courses in Shanghai, Weekend SQL Server BI courses in Shanghai, Evening SQL Server Business Intelligence (BI) training in Shanghai, SQL Server BI instructor-led in Shanghai, Online SQL Server Business Intelligence training in Shanghai, SQL Server BI on-site in Shanghai, SQL Server Business Intelligence (BI) instructor in Shanghai, SQL Server BI (Business Intelligence) trainer in Shanghai, SQL Server BI (Business Intelligence) instructor-led in Shanghai, SQL Server Business Intelligence (BI) boot camp in Shanghai, Weekend SQL Server Business Intelligence training in Shanghai, SQL Server Business Intelligence private courses in Shanghai, SQL Server Business Intelligence one on one training in Shanghai, SQL Server Business Intelligence coaching in Shanghai, SQL Server Business Intelligence (BI) classes in Shanghai, Evening SQL Server Business Intelligence courses in Shanghai